IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'SubsidyHeader')
BEGIN 
CREATE TABLE [dbo].[SubsidyHeader](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[IdHavaleh]Numeric(18,0) NULL,
	[UniqueCode] [VARCHAR](15)  NULL,
        [OTPCode] varchar(15)NULL,
        [TerminalNo] varchar(15)NULL,
	[Counter] [VARCHAR](6) NULL,
	[OrderTrace] [VARCHAR](20) NOT NULL,
	[CreditAmount]MONEY NULL,
	[CurrentCredit]MONEY NULL,
	[CreatedOn] [DATETIME] NULL,
	[CreatedBy] [SMALLINT] NULL,
        [levelNumber] [TINYINT] NULL,
 CONSTRAINT [PK_SubsidyHeader] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)  ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[SubsidyHeader] ADD  DEFAULT (NEWID()) FOR [Id]

ALTER TABLE [dbo].[SubsidyHeader] ADD  DEFAULT (GETDATE()) FOR [CreatedOn]

ALTER TABLE [dbo].[SubsidyHeader] ADD  CONSTRAINT [DF_SubsidyHeader_levelNumber]  DEFAULT ((0)) FOR [levelNumber]
END